IF EXISTS (SELECT * FROM SYSOBJECTS WHERE ID = OBJECT_ID('SubscriberUpdate') AND sysstat & 0xf = 4)
    DROP PROCEDURE [SubscriberUpdate]
GO
CREATE PROCEDURE [SubscriberUpdate]
(
	@SubscriberId int,
    @Name nvarchar(200),
    @Email nvarchar(200),
    @Telephone nvarchar(100),
    @UpdateDate datetime
)
AS
BEGIN
	
	UPDATE [subscriber]
	SET
        [name]=@Name,
        [email]=@Email,
        [telephone]=@Telephone,
        [update_date]=@UpdateDate
	WHERE
		[subscriber_id] = @SubscriberId

END
GO